image-4.png

Data Cleaning - Missing Entries

Since 'Tenure' is in string format, a check is done to see which type of tenure has the most of number of units.

Converting date and time within dataframe.

1. Private Residential Property Price Index Observation

image-2.png

Source - https://data.gov.sg/dataset/private-residential-property-price-index-by-type-of-property

2. Study the trend for transactions in terms of number of units within the districts for last 5 years.

image.png

image.png

Creating Parallel Coordinates Plots for Analysis

From the Parallel Coordinates Plot, we can observe that there is a high volume in the number of transactions within the number of units. And the highest Unit Price is $6210 per square feet.

image.png

image.png

4. Using Unit Price ($psf) median for analysis

image.png

Histogram Analysis

The graph indicates a Right Skewed histogram and the mean is more than median. Most of the units transacted are in the range of about 1000 to 2000 dollars per square feet. Thus, for our analysis in the dataset, using median might be more suitable for our analysis.

5. Unit Price($psf) Analysis - (mean and median)

Unit Price($psf) Analysis - (mean and median)

2017 to 2022 - Unit Price ($psf) observation using plotly for data visualization.

image.png

image-2.png

2017 - Use Plotly to analyze the Unit Price ($psf)

image-2.png

image.png

2018 - Use Plotly to analyze the Unit Price ($psf)

image.png

2019

image.png

image.png

2020

image.png

image.png

2021

image.png

image.png

Use Plotly to analyze and compare the Unit Price ($psf) through the 5 years with outliers

image-2.png

image.png

Study the trend and find the % change in median Unit Price ($psf) for frequency range of 3 months.

Median Resampling - Unit Price ($psf)

Analysis for Area(sqft) for year 2020 and 2021

Analysis for homes for smaller units and Family Unit of 4

Family Unit of 4 homes

Other Observations from data analysis

Pairplot Analysis

Scatter Plot Observation